package MyDAO;

import java.sql.*;
import MyDAO.ConnectionDao;

public class property 
{
	int Registration_number;
	String Location;
	int Price;
	int Property_id;
	int Completion_time;
	double size;
	
	public property()throws SQLException
	{
		try
		{
			ConnectionDao.createConnection();
		}
		catch(Exception e)
		{
			System.out.println("Connection not establish"+e.getStackTrace());
		}
	}

	public void insertPropertyRecord() throws SQLException
	{
		String insertQuery="insert into prperty values("+Registration_number+","+Property_id+","+"'Location'"+","+Completion_time+","+size+")";;
		try
		{
			ConnectionDao.pstmt=ConnectionDao.conn.prepareStatement(insertQuery);
		}
		catch(Exception e)
		{
			System.out.println(e);
		}
	}
}
